ΣΥΧΝΟΤΗΤΕΣ ΡΑΔΙΟΣΤΑΘΜΩΝ

pns_name_table_ref_map["show_string_kg"]["id"]."' AND status='active' AND gl_id='".$CFG->gls_digramma_map[$CFG->gl]["id"]."' AND table_ref_id=a.id LIMIT 1) AS show_string "; $c["order"] = array(array("field"=>"seira","type"=>"ASC"),array("field"=>"show_string","type"=>"ASC")); $kgs_adress = get_etetradio_kgs($c,false); $kgs_adress = $kgs_adress["data"]; $creterea = array();//radiostations $creterea["statuses"] = "'active'"; /* $creterea["from"] .= ", pr_int AS p2, ar AS a1 "; $creterea["where"] .= (($creterea["where"]!="")?" AND":"")." p2.value=a.id AND p2.pn_id='".$CFG->pns_name_table_ref_map["rs_id_ar"]["id"]."' AND p2.table_ref_id=a1.id AND p2.status='active' AND a1.status='active'"; $creterea["from"] .= ", pr AS p3 "; $creterea["where"] .= (($creterea["where"]!="")?" AND":"")." TRIM(p3.value)!='' AND p3.pn_id='".$CFG->pns_name_table_ref_map["periexomeno_ar"]["id"]."' AND p3.table_ref_id=a1.id AND p3.status='active' AND p3.gl_id=".$CFG->gls_digramma_map[$CFG->gl]["id"]; $creterea["from"] .= ", pr_int AS p4 "; $tmp = get_kg_descendants($kgs["data"],231); //programm $tmp[] = 231; $creterea["where"] .= (($creterea["where"]!="")?" AND":"")." p4.value IN (".join(",",$tmp).") AND p4.pn_id='".$CFG->pns_name_table_ref_map["kg_id_ar"]["id"]."' AND p4.table_ref_id=a1.id AND p4.status='active' "; $creterea["where"] .= (($creterea["where"]!="")?" AND":"")." a.perioxi_kg_id IN (".join(",",$katigories[$meros]["cildren"]).") "; */ $creterea["order"] = array("field"=>"syxnotita","type"=>"ASC"); //$creterea["limit1"] = 0; //$creterea["limit2"] = 1; $radiostations = get_radiostations($creterea,false); $radiostations = $radiostations["data"]; $radiostations_by_perioxi = array(); foreach($radiostations AS $value){ if(!isset($radiostations_by_perioxi[$value["perioxi_kg_id"]])){$radiostations_by_perioxi[$value["perioxi_kg_id"]] = array();} $radiostations_by_perioxi[$value["perioxi_kg_id"]][] = $value; } $katigories = array(); foreach($kgs_adress AS $value) { if($value["parent_id"]=="196"){ //Ellada $katigories[$value["onoma"]] = array("titlos"=>$value["show_string"],"id"=>$value["id"],"cildren"=>array_merge(get_kg_descendants($kgs_adress,$value["id"]),array($value["id"])),"syxnotites"=>array()); foreach($katigories[$value["onoma"]]["cildren"] AS $tmp_perioxi_kg_id){ if(isset($radiostations_by_perioxi[$tmp_perioxi_kg_id])){ foreach($radiostations_by_perioxi[$tmp_perioxi_kg_id] AS $tmp_value){ $katigories[$value["onoma"]]["syxnotites"][] = $tmp_value; } } } } } $tmp_toret = ""; //$tmp_toret = "

".var_export($katigories,true)."

"; if(is_array($katigories) and count($katigories)>0){ $tmp_toret .= ""; foreach($katigories AS $key=>$value){ $index[] = "[".$value["titlos"]."]"; $tmp_toret .= $right->general_td_hdelimter(); $tmp_toret .= ""; $tmp_toret .= ""; $tmp_toret .= ""; $tmp_toret .= ""; $tmp_toret .= ""; } $tmp_toret .= "

".toupper($value["titlos"])." [".$CFG->ftexts("top")->just_draw(true)."]

"; $tmp_toret .= ""; foreach($value["syxnotites"] AS $rs){ $tmp_toret .= ""; $tmp_toret .= " "; $tmp_toret .= " "; $tmp_toret .= " ";//".$CFG->ftexts("idx_rs_programma")->just_draw()." // $tmp_toret .= " "; $tmp_toret .= " ";//$CFG->ftexts("idx_rs_weburl")->just_draw() $tmp_toret .= " "; $tmp_toret .= ""; } $tmp_toret .= " ".$rs["syxnotita"]." ".$rs["typos_syxnotitas"]." ".$rs["onoma"]." ".(($rs["has_programm"]!="")?"" "))."' lang='".$CFG->gl."' charset='utf-8' class='black nonedecoration'>":"")." ".(($rs["has_ereyna"]!="")?"" "))."' lang='".$CFG->gl."' charset='utf-8' class='black nonedecoration'>".$CFG->ftexts("idx_rs_ereyna")->just_draw()."":"")." ".(($rs["weburl"]!="")?"" "))."' lang='".$CFG->gl."' charset='utf-8' class='black nonedecoration'>www":"")." ".(($rs["streamurl"]!="")?" " "))."'> ":"")." "; $tmp_toret .= "

"; } $tmp_toret = "".implode(", ",$index)."".$tmp_toret; ?>